﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Daxiu.aspx.cs" Inherits="Daxiu_Daxiu" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style2
        {
            font-size: medium;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <span class="style2"><strong>大修部分</strong></span><br />
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
        AutoGenerateColumns="False" DataKeyNames="JH,SBRQ" 
        DataSourceID="SqlDataSource1" onrowupdating="GridView1_RowUpdating">
        <Columns>
            <asp:CommandField ShowEditButton="True" EditText="录入" />
            <asp:BoundField DataField="JH" HeaderText="井号" ReadOnly="True" 
                SortExpression="JH" />
            <asp:BoundField DataField="SBRQ" DataFormatString="{0:d}" HeaderText="上报日期" 
                ReadOnly="True" SortExpression="SBRQ" />
            <asp:BoundField DataField="KGRQ" DataFormatString="{0:d}" HeaderText="开工日期" 
                SortExpression="KGRQ" />
            <asp:BoundField DataField="WGRQ" HeaderText="完工日期" SortExpression="WGRQ" />
            <asp:BoundField DataField="SGFS" HeaderText="施工方式" SortExpression="SGFS" />
            <asp:BoundField DataField="CSLB" HeaderText="措施类别" SortExpression="CSLB" />
            <asp:BoundField DataField="BZ" HeaderText="备注" SortExpression="BZ" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionStringForOracle %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionStringForOracle.ProviderName %>" 
        
        SelectCommand="SELECT &quot;JH&quot;, &quot;CSLB&quot;, &quot;KGRQ&quot;, &quot;WGRQ&quot;, &quot;SGFS&quot;, &quot;BZ&quot;, &quot;SBRQ&quot; FROM &quot;BC_DAXIU&quot; WHERE ((&quot;KGRQ&quot; IS NULL) AND (&quot;WGRQ&quot; IS NULL)) ORDER BY &quot;SBRQ&quot; DESC" 
        UpdateCommand="UPDATE BC_DAXIU SET KGRQ = :KGRQ , WGRQ = :WGRQ ,SGFS = :SGFS , CSLB = :CSLB,BZ = :BZ WHERE JH = :JH AND SBRQ = :SBRQ">
        <UpdateParameters>
            <asp:Parameter Name="KGRQ" />
            <asp:Parameter Name="WGRQ" />
            <asp:Parameter Name="SGFS" />
            <asp:Parameter Name="CSLB" />
            <asp:Parameter Name="BZ" />
            <asp:Parameter Name="JH" />
            <asp:Parameter Name="SBRQ" />
        </UpdateParameters>
    </asp:SqlDataSource>
</asp:Content>

